package com.joinway.admin.platform;

import org.apache.commons.lang3.StringUtils;

public final class HsqldbConstants {
	public static final String SYSTEM_CONFIG_DDL = StringUtils.join(
"create table system_config ("
,"	id IDENTITY PRIMARY KEY,"
,"	name varchar(45),"
,"	value varchar(255),"
,"	description varchar(255)"
,")"
);
	
	public static final String TREE_MENU_DDL = StringUtils.join(
"create table tree_menu ("
,"	id IDENTITY PRIMARY KEY,"
,"	text varchar(45),"
,"	parent_id NUMERIC,"
,"	status char(1),"
,"	url varchar(255),"
,"	\"order\" NUMERIC,"
,"	icon varchar(45),"
,"	update_by varchar(45),"
,"	update_date TIME"
,")"
);
	
	public static final String EXCEPTION_CONFIG_DDL = StringUtils.join(
"create table exception_config ("
,"	id IDENTITY PRIMARY KEY,"
,"	code varchar(50),"
,"	exception varchar(40),"
,"	text varchar(100)"
,")"
);
}
